﻿CREATE TABLE [Users](
--用户信息
	[LoginID] [varchar](30) NOT NULL CONSTRAINT PK_Users PRIMARY KEY (LoginID),
	[Name] [nvarchar](10) NULL,
	[Pwd] [varchar](100) NOT NULL,
	[Depict] [ntext] NULL
)
GO


CREATE TABLE [Industry](
--行业信息
	[IndustryID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](30) NOT NULL,
	[Depict] [ntext] NULL,
 CONSTRAINT [PK_INDUSTRY] PRIMARY KEY CLUSTERED 
(
	[IndustryID] ASC
)
)
GO


CREATE TABLE [Customer](
--客户档案
	[CustomerID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](10) NOT NULL,
	[Duties] [int] NOT NULL,
	[IndustryID] [int] NOT NULL,
	[Birthday] [datetime] NULL,
	[Mobile] [varchar](20) NOT NULL,
	[QQ] [varchar](20) NULL,
	[Email] [varchar](100) NULL,
	[CompanyName] [nvarchar](50) NULL,
	[WebSite] [varchar](100) NULL,
	[Phone] [varchar](20) NULL,
	[Fax] [varchar](20) NULL,
	[Address] [nvarchar](100) NULL,
	[Depict] [ntext] NULL,
 CONSTRAINT [PK_CUSTOMER] PRIMARY KEY CLUSTERED 
(
	[CustomerID] ASC
)
) 
GO


CREATE TABLE [Student](
--学生信息
	[ID] [varchar](20) NOT NULL,
	[Name] [nvarchar](10) NOT NULL,
	[Sex] [int] NOT NULL,
	[NativePlace] [nvarchar](30) NULL,
	[ClassName] [nvarchar](50) NOT NULL,
	[Birthday] [datetime] NOT NULL,
	[Mobile] [varchar](11) NULL,
	[Skill] [ntext] NULL,
 CONSTRAINT [PK_TB_Student] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)
) 
GO